CREATE TABLE [dbo].[DnnProduct_PWSalesDashBoard_ReportData]
(
[ReportDataId] [int] NOT NULL IDENTITY(1, 1),
[DBName] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PWVersion] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UseCDS] [bit] NULL,
[ProductsTotal] [int] NULL,
[AveragePricePerProductsTotal] [decimal] (18, 2) NULL,
[CustomersHavePlaceOrders] [int] NULL,
[CustomersHavePlaceMoreThanOneOrder] [int] NULL,
[PureCDSProductsTotal] [int] NULL,
[AvgPricePerPureCDSProductsTotal] [decimal] (18, 2) NULL,
[CDSBundleProductsTotal] [int] NULL,
[AvgPricePerCDSBundleProductsTotal] [decimal] (18, 2) NULL,
[NumOfOrdersPlaced] [int] NULL,
[OrdersTotal] [decimal] (18, 2) NULL,
[LowestOrderTotal_OrderId] [int] NULL,
[LowestOrderTotal_OrderTotal] [decimal] (18, 2) NULL,
[HighestOrderTotal_OrderId] [int] NULL,
[HighestOrderTotal_OrderTotal] [decimal] (18, 2) NULL,
[OrderItemsTotal] [int] NULL,
[LowestOrderItemsTotal_OrderId] [int] NULL,
[LowestOrderItemsTotal_ItemsTotal] [int] NULL,
[HighestOrderItemsTotal_OrderId] [int] NULL,
[HighestOrderItemsTotal_OrderItemsTotal] [int] NULL,
[AvgTotalPerOrder] [decimal] (18, 2) NULL,
[AvgNumItemsPerOrder] [decimal] (18, 2) NULL,
[NumOfPureCDSOrdersPlaced] [int] NULL,
[PureCDSOrdersTotal] [decimal] (18, 2) NULL,
[LowestPureCDSOrderTotal_OrderId] [int] NULL,
[LowestPureCDSOrderTotal_OrderTotal] [decimal] (18, 2) NULL,
[HighestPureCDSOrderTotal_OrderId] [int] NULL,
[HighestPureCDSOrderTotal_OrderTotal] [decimal] (18, 2) NULL,
[PureCDSOrderItemsTotal] [int] NULL,
[LowestPureCDSOrderItemsTotal_OrderId] [int] NULL,
[LowestPureCDSOrderItemsTotal_ItemsTotal] [int] NULL,
[HighestPureCDSOrderItemsTotal_OrderId] [int] NULL,
[HighestPureCDSOrderItemsTotal_OrderItemsTotal] [int] NULL,
[AvgTotalPerPureCDSOrder] [decimal] (18, 2) NULL,
[AvgNumItemsPerPureCDSOrder] [decimal] (18, 2) NULL,
[NumOfBundleCDSOrdersPlaced] [int] NULL,
[BundleCDSOrdersTotal] [decimal] (18, 2) NULL,
[LowestBundleCDSOrderTotal_OrderId] [int] NULL,
[LowestBundleCDSOrderTotal_OrderTotal] [decimal] (18, 2) NULL,
[HighestBundleCDSOrderTotal_OrderId] [int] NULL,
[HighestBundleCDSOrderTotal_OrderTotal] [decimal] (18, 2) NULL,
[BundleCDSOrderItemsTotal] [int] NULL,
[LowestBundleCDSOrderItemsTotal_OrderId] [int] NULL,
[LowestBundleCDSOrderItemsTotal_ItemsTotal] [int] NULL,
[HighestBundleCDSOrderItemsTotal_OrderId] [int] NULL,
[HighestBundleCDSOrderItemsTotal_OrderItemsTotal] [int] NULL,
[AvgTotalPerBundleCDSOrder] [decimal] (18, 2) NULL,
[AvgNumItemsPerBundleCDSOrder] [decimal] (18, 2) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DnnProduct_PWSalesDashBoard_ReportData] ADD CONSTRAINT [PK_DnnProduct_PWSalesDashBoard_ReportData] PRIMARY KEY CLUSTERED  ([ReportDataId]) ON [PRIMARY]
GO
